GL_Speed_Analysis
Huajie Yang
2/13/2020
Load station metadata
Organize speed data
Convert station level data to route level data
# 09/12/2004 - 09/11/2014 analysis
Plot speed data
Base DID models
Using I-84 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ==========================================================================================================
## Dependent variable:
## ---------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## ----------------------------------------------------------------------------------------------------------
## Time Period (after = 1) 5.690*** 7.130*** 5.050*** 1.350***
## (0.498) (0.584) (0.505) (0.433)
##
## Group (experimental group = 1) 0.247 9.770*** -5.310*** -14.800***
## (0.519) (0.603) (0.519) (0.441)
##
## Time Period × Group -0.158 -0.157 2.790*** 4.090***
## (0.696) (0.809) (0.719) (0.614)
##
## Constant 35.200*** 34.600*** 51.400*** 46.100***
## (0.379) (0.444) (0.374) (0.319)
##
## ----------------------------------------------------------------------------------------------------------
## Observations 4,414 4,429 4,454 4,518
## R2 0.056 0.160 0.096 0.300
## Adjusted R2 0.055 0.160 0.095 0.300
## Residual Std. Error 11.500 (df = 4410) 13.400 (df = 4425) 12.000 (df = 4450) 10.300 (df = 4514)
## ==========================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Using I-205 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-205 as the experimental corridor
## =======================================================================================================
## Dependent variable:
## ------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## -------------------------------------------------------------------------------------------------------
## Time Period (after = 1) 5.690*** 7.130*** 5.050*** 1.350***
## (0.381) (0.463) (0.134) (0.265)
##
## Group (experimental group = 1) 18.900*** 16.400*** 7.580*** 8.350***
## (0.407) (0.490) (0.142) (0.280)
##
## Time Period × Group -4.390*** -6.100*** -2.180*** -1.270***
## (0.547) (0.658) (0.192) (0.380)
##
## Constant 35.200*** 34.600*** 51.400*** 46.100***
## (0.290) (0.352) (0.100) (0.195)
##
## -------------------------------------------------------------------------------------------------------
## Observations 4,173 4,214 4,426 4,459
## R2 0.479 0.297 0.587 0.272
## Adjusted R2 0.479 0.296 0.586 0.272
## Residual Std. Error 8.770 (df = 4169) 10.600 (df = 4210) 3.180 (df = 4422) 6.310 (df = 4455)
## =======================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Multiple time periods DID models
Using I-84 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ===============================================================================================
## Dependent variable:
## ---------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## -----------------------------------------------------------------------------------------------
## Group 0.247 9.770*** -5.310*** -14.800***
## (0.500) (0.571) (0.506) (0.436)
##
## year_1st 9.050*** 9.650*** 5.520*** 1.540**
## (0.779) (0.894) (0.816) (0.711)
##
## year_2nd 5.050*** 9.910*** 5.320*** 3.980***
## (0.778) (0.900) (0.815) (0.728)
##
## year_3rd 4.830*** 5.400*** 4.920*** 0.519
## (0.778) (0.890) (0.817) (0.704)
##
## year_4th 5.670*** 6.560*** 5.010*** -0.050
## (0.786) (0.915) (0.829) (0.716)
##
## year_5th 3.660*** 3.830*** 4.430*** 0.868
## (0.814) (0.934) (0.857) (0.738)
##
## Group:year_1st -14.200*** -18.200*** 7.290*** 7.880***
## (1.110) (1.270) (1.340) (1.170)
##
## Group:year_2nd 5.470*** 2.150* 0.621 0.469
## (1.100) (1.260) (1.150) (1.020)
##
## Group:year_3rd 5.190*** 7.820*** -1.350 1.990**
## (1.100) (1.250) (1.150) (0.995)
##
## Group:year_4th -0.379 1.240 -2.650** 3.450***
## (1.160) (1.330) (1.220) (1.060)
##
## Group:year_5th 2.670** 5.660*** 11.800*** 8.080***
## (1.130) (1.290) (1.200) (1.030)
##
## Constant 35.200*** 34.600*** 51.400*** 46.100***
## (0.365) (0.420) (0.365) (0.316)
##
## -----------------------------------------------------------------------------------------------
## Observations 4,414 4,429 4,454 4,518
## R2 0.125 0.249 0.141 0.316
## Adjusted R2 0.123 0.247 0.139 0.314
## Residual Std. Error 11.100 (df = 4402) 12.700 (df = 4417) 11.700 (df = 4442) 10.200 (df = 4506)
## ===============================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Using I-205 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-205 as the experimental corridor
## =======================================================================================================
## Dependent variable:
## ------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## -------------------------------------------------------------------------------------------------------
## Time Period (after = 1) 18.900*** 16.400*** 7.580*** 8.350***
## (0.403) (0.485) (0.139) (0.277)
##
## Group (experimental group = 1) 9.050*** 9.650*** 5.520*** 1.540***
## (0.612) (0.742) (0.217) (0.434)
##
## Time Period × Group 5.050*** 9.910*** 5.320*** 3.980***
## (0.611) (0.747) (0.217) (0.445)
##
## year_3rd 4.830*** 5.400*** 4.920*** 0.519
## (0.611) (0.739) (0.218) (0.430)
##
## year_4th 5.670*** 6.560*** 5.010*** -0.050
## (0.617) (0.760) (0.221) (0.438)
##
## year_5th 3.660*** 3.830*** 4.430*** 0.868*
## (0.639) (0.775) (0.228) (0.451)
##
## Group:year_1st -6.030*** -7.690*** -4.260*** -1.160*
## (0.866) (1.050) (0.310) (0.615)
##
## Group:year_2nd -3.350*** -7.330*** -3.490*** -4.040***
## (0.864) (1.050) (0.308) (0.623)
##
## Group:year_3rd -2.630*** -3.760*** -0.096 1.970***
## (0.869) (1.050) (0.314) (0.622)
##
## Group:year_4th -6.350*** -7.620*** -1.580*** -0.279
## (0.897) (1.070) (0.318) (0.635)
##
## Group:year_5th -6.700*** -5.770*** -1.170*** -3.270***
## (1.210) (1.380) (0.329) (0.651)
##
## Constant 35.200*** 34.600*** 51.400*** 46.100***
## (0.286) (0.349) (0.097) (0.193)
##
## -------------------------------------------------------------------------------------------------------
## Observations 4,173 4,214 4,426 4,459
## R2 0.491 0.312 0.606 0.293
## Adjusted R2 0.490 0.310 0.605 0.292
## Residual Std. Error 8.680 (df = 4161) 10.500 (df = 4202) 3.110 (df = 4414) 6.220 (df = 4447)
## =======================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
09/12/2008 - 09/11/2014
Plot speed data
Base DID model
Using I-84 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ========================================================================================================
## Dependent variable:
## -------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## --------------------------------------------------------------------------------------------------------
## Time Period (after = 1) -4.600*** -3.100*** 0.931*** -0.279
## (0.728) (0.879) (0.332) (0.483)
##
## Group (experimental group = 1) -9.640*** -1.770 2.560*** -6.520***
## (1.020) (1.160) (0.420) (0.612)
##
## Time Period × Group 9.730*** 11.400*** -5.090*** -4.210***
## (1.110) (1.270) (0.462) (0.673)
##
## Constant 45.500*** 44.800*** 55.500*** 47.700***
## (0.666) (0.805) (0.305) (0.443)
##
## --------------------------------------------------------------------------------------------------------
## Observations 2,872 2,912 2,807 2,823
## R2 0.030 0.116 0.084 0.363
## Adjusted R2 0.029 0.115 0.083 0.362
## Residual Std. Error 10.400 (df = 2868) 12.500 (df = 2908) 4.620 (df = 2803) 6.770 (df = 2819)
## ========================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Using I-205 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ======================================================================================================
## Dependent variable:
## -----------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## ------------------------------------------------------------------------------------------------------
## Time Period (after = 1) -4.600*** -3.100*** 0.931*** -0.279
## (0.470) (0.647) (0.147) (0.462)
##
## Group (experimental group = 1) 10.200*** 8.550*** 4.110*** 7.190***
## (0.607) (0.823) (0.188) (0.584)
##
## Time Period × Group 4.340*** 1.730* 1.280*** -0.119
## (0.668) (0.906) (0.205) (0.640)
##
## Constant 45.500*** 44.800*** 55.500*** 47.700***
## (0.431) (0.592) (0.135) (0.424)
##
## ------------------------------------------------------------------------------------------------------
## Observations 2,805 2,841 2,895 2,925
## R2 0.523 0.235 0.627 0.232
## Adjusted R2 0.522 0.234 0.627 0.231
## Residual Std. Error 6.700 (df = 2801) 9.190 (df = 2837) 2.050 (df = 2891) 6.470 (df = 2921)
## ======================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Multiple time periods DID models
Using I-84 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ============================================================================================
## Dependent variable:
## ------------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## --------------------------------------------------------------------------------------------
## Group -9.640*** -1.770* 2.560*** -6.520***
## (0.951) (1.050) (0.288) (0.586)
##
## year_1st -1.250 -0.580 1.400*** -0.093
## (0.862) (1.010) (0.288) (0.587)
##
## year_2nd -5.240*** -0.323 1.190*** 2.350***
## (0.861) (1.020) (0.288) (0.596)
##
## year_3rd -5.470*** -4.830*** 0.794*** -1.110*
## (0.861) (1.010) (0.289) (0.584)
##
## year_4th -4.620*** -3.670*** 0.887*** -1.680***
## (0.867) (1.030) (0.291) (0.590)
##
## year_5th -6.640*** -6.400*** 0.311 -0.762
## (0.886) (1.040) (0.297) (0.601)
##
## Group:year_1st -4.360*** -6.710*** -0.581 -0.424
## (1.290) (1.460) (0.443) (0.904)
##
## Group:year_2nd 15.400*** 13.700*** -7.250*** -7.830***
## (1.280) (1.460) (0.402) (0.828)
##
## Group:year_3rd 15.100*** 19.400*** -9.220*** -6.310***
## (1.270) (1.450) (0.403) (0.817)
##
## Group:year_4th 9.510*** 12.800*** -10.500*** -4.850***
## (1.310) (1.500) (0.418) (0.851)
##
## Group:year_5th 12.600*** 17.200*** 3.960*** -0.217
## (1.290) (1.470) (0.413) (0.833)
##
## Constant 45.500*** 44.800*** 55.500*** 47.700***
## (0.619) (0.728) (0.210) (0.425)
##
## --------------------------------------------------------------------------------------------
## Observations 2,872 2,912 2,807 2,823
## R2 0.165 0.278 0.570 0.416
## Adjusted R2 0.162 0.275 0.568 0.414
## Residual Std. Error 9.630 (df = 2860) 11.300 (df = 2900) 3.170 (df = 2795) 6.480 (df = 2811)
## ============================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Using I-205 as the experimental corridor
##
## GL Route Travel Speed 09/12/2004-09/12/2014 & I-84 as the experimental corridor
## ===========================================================================================
## Dependent variable:
## -----------------------------------------------------------------------
## Travel Speed
## AM Inbound PM Inbound AM Outbound PM Outbound
## (1) (2) (3) (4)
## -------------------------------------------------------------------------------------------
## Group 10.200*** 8.550*** 4.110*** 7.190***
## (0.589) (0.807) (0.171) (0.573)
##
## year_1st -1.250** -0.580 1.400*** -0.093
## (0.583) (0.808) (0.170) (0.574)
##
## year_2nd -5.240*** -0.323 1.190*** 2.350***
## (0.582) (0.811) (0.169) (0.583)
##
## year_3rd -5.470*** -4.830*** 0.794*** -1.110*
## (0.582) (0.806) (0.170) (0.571)
##
## year_4th -4.620*** -3.670*** 0.887*** -1.680***
## (0.586) (0.820) (0.171) (0.577)
##
## year_5th -6.640*** -6.400*** 0.311* -0.762
## (0.599) (0.831) (0.175) (0.587)
##
## Group:year_1st 2.710*** 0.142 -0.799*** -0.009
## (0.823) (1.130) (0.238) (0.801)
##
## Group:year_2nd 5.390*** 0.502 -0.023 -2.880***
## (0.822) (1.140) (0.237) (0.807)
##
## Group:year_3rd 6.110*** 4.070*** 3.370*** 3.120***
## (0.825) (1.140) (0.240) (0.806)
##
## Group:year_4th 2.390*** 0.208 1.880*** 0.876
## (0.842) (1.150) (0.242) (0.817)
##
## Group:year_5th 2.040* 2.060 2.300*** -2.120**
## (1.040) (1.370) (0.247) (0.830)
##
## Constant 45.500*** 44.800*** 55.500*** 47.700***
## (0.418) (0.581) (0.123) (0.415)
##
## -------------------------------------------------------------------------------------------
## Observations 2,805 2,841 2,895 2,925
## R2 0.551 0.266 0.692 0.264
## Adjusted R2 0.549 0.264 0.691 0.261
## Residual Std. Error 6.510 (df = 2793) 9.010 (df = 2829) 1.860 (df = 2883) 6.340 (df = 2913)
## ===========================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01